<html><head><title>dbcc traceon / traceoff</title><meta name="HandheldFriendly" content="True"></head><body><div align="center"><h3><b>Stored procedures<br>dbcc traceon / traceoff statement</b></h3></div><br><table><tr><td valign=top>1</td><td><a href="y307386.html">Disable procedure cache optimisation</a></td></tr><tr><td valign=top>2</td><td><a href="y307393.html">Do not recompile a stored procedure that inherits a temp table from a parent procedure.</a></td></tr></table></body></html>